Location:
Search - sql excel
Search list
Description: 用VC++做的学生管理系统，SQL数据库里面有很多使用技术比如操作EXCEL-VC++ to do with the Student Management System, SQL database there are a lot of use of technology such as EXCEL to operate and so on
Platform: |
Size: 8350720 |
Author: zolingwu |
Hits:
Description: 运用java语言直接对excel表格进行处理
java，sql，excel的集成-Directly to the use of java language to deal with excel table java, sql, excel integration
Platform: |
Size: 4096 |
Author: 梁丁宏 |
Hits:
Description: 用VB编写的数据库转换程序，可以在Access2000,dBase2,dBase3,CSV,Excel2000,HTML,TEXT几种格式间进行互相转换，如果是Access数据库的话，还可以选择对应的表，支持SQL查询语句，程序暂时不支持MSSQL数据库，有点遗憾。-VB database prepared by the conversion process, you can Access2000, dBase2, dBase3, CSV, Excel2000, HTML, TEXT several format conversion between each other, if the Access database, then have the option of the corresponding table to support SQL query, the program do not support MSSQL database, with some regret.
Platform: |
Size: 17408 |
Author: xiongpeng |
Hits:
Description: Excel To SQL
by get list of the excel files
Platform: |
Size: 3072 |
Author: s |
Hits:
Description: 一个完整delphi桌面程序，实用的业务分组排名系统，其中包括ado连接及sql操作access，Excel数据导入导出，数据备份恢复，表格精细控制、显示及编辑数据。
适合各业务需要排名的单位个人，注释完整，界面易用，简单修改即可再利用。-A complete desktop delphi program and practical ranking system business division, including the ado connection and sql operator access, Excel data import and export, data backup and recovery, forms fine control, display and edit data. Suited to the needs of the business units ranking individuals, notes complete, easy-to-use interface, simple to modify and reuse.
Platform: |
Size: 573440 |
Author: 成功 |
Hits:
Description: VB 数据按SQL查询语句导出到EXCEL,如果系统导出频繁,建议做公共过程调用此段代码/-VB query SQL data export to EXCEL, frequent if the system is derived, it is recommended to do This public procedure call code /
Platform: |
Size: 1024 |
Author: 罗斌 |
Hits:
Description: JAVA导入excel文件功能，实现从excel导入oracle或sql等数据库中！-Import excel file JAVA function, import from excel, such as oracle or sql database!
Platform: |
Size: 8192 |
Author: Jayden |
Hits:
Description: 基于java和关系数据库的excel 2007数据存取技术研究
1.2 项目背景和内容概要
在企业应用中，经常用Excel来处理表格，要把Excel表格中的数据存入数据库， 或者进行相反的操作，过去的方法有两个：一是采用文本格式的CSV文档做过渡， 缺点是无法携带Excel的格式信息；二是使用COM技术。用Java直接存取Excel文档 是困难的。由于Office 2007采用了开放的OpenXML标准，大大提高了用Java直接 存取Office文档的便捷性。本项目的研究内容包括：（1）学习OpenXML，研究 Excel 2007工作簿的存取技术；（2）采用Java实现Excel 2007工作簿和SQL Server数据库的互相转换-Java-based relational database and data access excel 2007 Research 1.2 Project background and content of a summary application in an enterprise often use Excel to handle forms, tables to Excel data into a database, or operation contrary to the past There are two methods: first, using the CSV text file to do the transition, the demerit is that the format of Excel can not carry information second is the use of COM technology. Direct access to Excel with Java is difficult to document. As a result of Office 2007' s OpenXML adoption of an open standard, Java greatly enhanced by direct access to the convenience of Office documents. This project include: (1) study OpenXML, Research Excel 2007 workbook access technology (2) the use of Java to achieve Excel 2007 workbooks, and SQL Server database conversion with each other
Platform: |
Size: 651264 |
Author: 南才北往 |
Hits:
Description: 一个C# 操作excel的例子，可以使用 T-sql 语句 查询汇总 excel里面的数据-Operation of a C# example of excel, you can use T-sql statement summary query data inside excel
Platform: |
Size: 1048576 |
Author: 张海滨 |
Hits:
Description: excel数据导入文件，用友软件使用，excel导入到sql工具-excel data into documents, UFIDA software, excel into sql tools
Platform: |
Size: 2234368 |
Author: xjdlydd |
Hits:
Description: SQL命令读取EXCEL数据,也可以插入到数据库表中，时间处理命令等-SQL命令读取EXCEL数据,也可以插入到数据库表中，时间处理命令等……
Platform: |
Size: 1024 |
Author: Mr wang |
Hits:
Description: Excel是一种非常灵活的电子表格软件，用它可以存储各种数据，本节将对如何将Excel导入SQL Server2000数据库进行详细介绍。
开发环境：NET2.0
开发工具：vs2005
开发语言：c#
数据库：server2-Excel is a very flexible electronic forms software, use it to store data, this section will be how to integrate Excel into SQL Server2000 database details. Development Environment: NET2.0 Tools: vs2005 development language: c# database: server2000
Platform: |
Size: 160768 |
Author: taowen |
Hits:
Description: Stok report using excel and crystall report to extract data from sql server (ERP System) and combine it with excel stock
Platform: |
Size: 2919424 |
Author: qhoore |
Hits:
Description: ASP Snippets Read and Import Excel Sheet into SQL Server Database in ASP_Net-ASP Snippets Read and Import Excel Sheet into SQL Server Database in ASP_Net
Platform: |
Size: 398336 |
Author: savitha |
Hits:
Description: 实现将文本数据导入excel数据到sql-导入excel数据到sql
Platform: |
Size: 241664 |
Author: 曾飞 |
Hits:
Description: 本程序实现了把excel内容导入到sql数据库的功能！！
-This program implements the contents of the excel into sql database features! !
Platform: |
Size: 647168 |
Author: haibin |
Hits:
Description: VB 可视化数据库管理源码示例，源码中包括了sql server / excel/access /TXT 读取样例，可做为常用数据库编程参考。-VB source code sample visual database management, source code included in the sql server/excel/access/TXT read the sample can be used as common reference database programming.
Platform: |
Size: 128000 |
Author: ye chun |
Hits:
Description: 一个针对项目管理的系统,采用c#+Sql server 开发通过统计数据生成EXCEL等文件． -One for the project management system that uses c#+ Sql server development of statistical data generated by EXCEL and other documents.
Platform: |
Size: 2701312 |
Author: Fitzz |
Hits:
Description: 这是一个由c++和sql编写的系统。它可以进行各种数据的处理、统计分析和辅助决策操作。 -This is a c++ and sql prepared systems. It can be a variety of data processing, statistical analysis and decision support operations.
Platform: |
Size: 5618688 |
Author: 叶广 |
Hits:
Description: Excel导入SQLserver源码
Excel是一种非常灵活的电子表格软件，用它可以存储各种数据，本节将对如何将Excel导入SQL Server2000数据库进行详细介绍。
开发环境：NET2.0
开发工具：vs2005
开发语言：c#
数据库：server2000
1．方案分析
通过Microsoft.Jet.OLEDB.4.0方式可实现使用ADO.NET访问Excel的目的，如以下示例代码为连接Excel数据的字符串：
string strOdbcCon = @"Provider=Microsoft.Jet.OLEDB.4.0 Persist Security Info=False Data Source= Server.MapPath(("~upfiles")+ filename) Extended Properties=Excel 8.0"
2．实施过程
程序开发步骤：
（1）新建一个网站，命名为HHASPX，其主页默认为Default.aspx。
（2）Default.aspx页面中添加一个Table表格，用来布局页面，然后在该Table表格中添加一个一个FileUpload控件；一个Button控件和一个GridView控件。FileUpload控件用来选择上传文件，Button控件用来将指定Excel上传到服务器并将数据表中的数据导入到SQL Server数据库中；GridView控件用来显示导入SQL Server数据库中的Excel数据。
App_Data下为Sql数据库，附加后修改cs文件中的数据库连接字符串： string strConn = "Data Source=. DataBase=hhaspx Uid=sa Pwd=sa"
Platform: |
Size: 156672 |
Author: wanghu |
Hits:
«
1
2
3
45
6
7
8
9
10
...
17
»